BackOrder_Profile

Dataset statistics

Number of variables	23
Number of observations	1929935
Missing cells	115638
Missing cells (%)	0.3%
Duplicate rows	183366
Duplicate rows (%)	9.5%
Total size in memory	353.4 MiB
Average record size in memory	192.0 B

Variable types

Unsupported	1
Numeric	15
Boolean	7

Alerts

Dataset has 183366 (9.5%) duplicate rows	Duplicates
`potential_issue` is highly imbalanced (99.4%)	Imbalance
`oe_constraint` is highly imbalanced (99.8%)	Imbalance
`stop_auto_buy` is highly imbalanced (77.4%)	Imbalance
`rev_stop` is highly imbalanced (99.5%)	Imbalance
`went_on_backorder` is highly imbalanced (93.8%)	Imbalance
`lead_time` has 115617 (6.0%) missing values	Missing
`national_inv` is highly skewed (γ1 = 340.2206342)	Skewed
`in_transit_qty` is highly skewed (γ1 = 168.9800308)	Skewed
`forecast_3_month` is highly skewed (γ1 = 142.7827259)	Skewed
`forecast_6_month` is highly skewed (γ1 = 138.8179394)	Skewed
`forecast_9_month` is highly skewed (γ1 = 142.6836687)	Skewed
`sales_1_month` is highly skewed (γ1 = 193.7199727)	Skewed
`sales_3_month` is highly skewed (γ1 = 141.8139424)	Skewed
`sales_6_month` is highly skewed (γ1 = 138.9269756)	Skewed
`sales_9_month` is highly skewed (γ1 = 135.4356641)	Skewed
`min_bank` is highly skewed (γ1 = 130.9625785)	Skewed
`pieces_past_due` is highly skewed (γ1 = 414.2698848)	Skewed
`local_bo_qty` is highly skewed (γ1 = 149.6208797)	Skewed
`sku` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`national_inv` has 123076 (6.4%) zeros	Zeros
`in_transit_qty` has 1541941 (79.9%) zeros	Zeros
`forecast_3_month` has 1347744 (69.8%) zeros	Zeros
`forecast_6_month` has 1240252 (64.3%) zeros	Zeros
`forecast_9_month` has 1182117 (61.3%) zeros	Zeros
`sales_1_month` has 1100061 (57.0%) zeros	Zeros
`sales_3_month` has 869086 (45.0%) zeros	Zeros
`sales_6_month` has 739645 (38.3%) zeros	Zeros
`sales_9_month` has 669802 (34.7%) zeros	Zeros
`min_bank` has 997258 (51.7%) zeros	Zeros
`pieces_past_due` has 1901631 (98.5%) zeros	Zeros
`perf_6_month_avg` has 44675 (2.3%) zeros	Zeros
`perf_12_month_avg` has 37885 (2.0%) zeros	Zeros
`local_bo_qty` has 1903730 (98.6%) zeros	Zeros

Reproduction

Analysis started	2023-05-09 10:54:24.836197
Analysis finished	2023-05-09 10:56:38.155147
Duration	2 minutes and 13.32 seconds
Software version	ydata-profiling vv4.1.2
Download configuration	config.json

sku
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	29.4 MiB

national_inv
Real number (ℝ)

SKEWED ZEROS

Distinct	15903
Distinct (%)	0.8%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	496.56852

Minimum	-27256
Maximum	12334404
Zeros	123076
Zeros (%)	6.4%
Negative	6654
Negative (%)	0.3%
Memory size	29.4 MiB

Quantile statistics

Minimum	-27256
5-th percentile	0
Q1	4
median	15
Q3	80
95-th percentile	924
Maximum	12334404
Range	12361660
Interquartile range (IQR)	76

Descriptive statistics

Standard deviation	29573.442
Coefficient of variation (CV)	59.555612
Kurtosis	131267.42
Mean	496.56852
Median Absolute Deviation (MAD)	13
Skewness	340.22063
Sum	9.5834446 × 10⁸
Variance	8.7458847 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	123407	6.4%
0	123076	6.4%
3	103497	5.4%
4	79724	4.1%
5	67702	3.5%
1	67101	3.5%
6	58162	3.0%
7	53108	2.8%
10	52847	2.7%
8	45940	2.4%
Other values (15893)	1155370	59.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-27256	1	< 0.1%
-25414	3	< 0.1%
-22154	3	< 0.1%
-17698	1	< 0.1%
-17669	2	< 0.1%
-13491	1	< 0.1%
-9925	1	< 0.1%
-8230	1	< 0.1%
-8170	1	< 0.1%
-8130	1	< 0.1%

Value	Count	Frequency (%)
12334404	1	< 0.1%
12324456	1	< 0.1%
12315072	1	< 0.1%
12309096	1	< 0.1%
12285100	1	< 0.1%
12181612	1	< 0.1%
12166440	1	< 0.1%
12145792	1	< 0.1%
6363276	1	< 0.1%
6352932	1	< 0.1%

lead_time
Real number (ℝ)

Distinct	32
Distinct (%)	< 0.1%
Missing	115617
Missing (%)	6.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.8786266

Minimum	0
Maximum	52
Zeros	12026
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	29.4 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	4
median	8
Q3	9
95-th percentile	12
Maximum	52
Range	52
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	7.0542125
Coefficient of variation (CV)	0.89536069
Kurtosis	26.243386
Mean	7.8786266
Median Absolute Deviation (MAD)	1
Skewness	4.556573
Sum	14294334
Variance	49.761914
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
8	780719	40.5%
2	384319	19.9%
12	228997	11.9%
4	147045	7.6%
9	141423	7.3%
52	34418	1.8%
3	18602	1.0%
10	16248	0.8%
0	12026	0.6%
14	11820	0.6%
Other values (22)	38701	2.0%
(Missing)	115617	6.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	12026	0.6%
1	24	< 0.1%
2	384319	19.9%
3	18602	1.0%
4	147045	7.6%
5	4609	0.2%
6	5826	0.3%
7	239	< 0.1%
8	780719	40.5%
9	141423	7.3%

Value	Count	Frequency (%)
52	34418	1.8%
40	56	< 0.1%
35	40	< 0.1%
30	356	< 0.1%
28	96	< 0.1%
26	120	< 0.1%
25	8	< 0.1%
24	148	< 0.1%
23	16	< 0.1%
22	152	< 0.1%

in_transit_qty
Real number (ℝ)

SKEWED ZEROS

Distinct	5543
Distinct (%)	0.3%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	43.064419

Minimum	0
Maximum	489408
Zeros	1541941
Zeros (%)	79.9%
Negative	0
Negative (%)	0.0%
Memory size	29.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	66
Maximum	489408
Range	489408
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1295.4208
Coefficient of variation (CV)	30.081001
Kurtosis	41191.441
Mean	43.064419
Median Absolute Deviation (MAD)	0
Skewness	168.98003
Sum	83111487
Variance	1678115.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1541941	79.9%
1	41250	2.1%
2	25128	1.3%
3	19506	1.0%
4	17436	0.9%
5	14608	0.8%
6	12907	0.7%
10	10109	0.5%
8	9932	0.5%
7	9209	0.5%
Other values (5533)	227908	11.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1541941	79.9%
1	41250	2.1%
2	25128	1.3%
3	19506	1.0%
4	17436	0.9%
5	14608	0.8%
6	12907	0.7%
7	9209	0.5%
8	9932	0.5%
9	7179	0.4%

Value	Count	Frequency (%)
489408	1	< 0.1%
487680	1	< 0.1%
328060	1	< 0.1%
327156	1	< 0.1%
292093	1	< 0.1%
288960	1	< 0.1%
288768	1	< 0.1%
285365	1	< 0.1%
276703	1	< 0.1%
265272	1	< 0.1%

forecast_3_month
Real number (ℝ)

SKEWED ZEROS

Distinct	8293
Distinct (%)	0.4%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	178.53996

Minimum	0
Maximum	1510592
Zeros	1347744
Zeros (%)	69.8%
Negative	0
Negative (%)	0.0%
Memory size	29.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4
95-th percentile	300
Maximum	1510592
Range	1510592
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	5108.7715
Coefficient of variation (CV)	28.614163
Kurtosis	27297.357
Mean	178.53996
Median Absolute Deviation (MAD)	0
Skewness	142.78273
Sum	3.4457033 × 10⁸
Variance	26099546
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1347744	69.8%
1	35757	1.9%
2	29961	1.6%
5	22258	1.2%
4	21158	1.1%
3	18427	1.0%
10	16398	0.8%
6	15417	0.8%
20	12596	0.7%
12	12576	0.7%
Other values (8283)	397642	20.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1347744	69.8%
1	35757	1.9%
2	29961	1.6%
3	18427	1.0%
4	21158	1.1%
5	22258	1.2%
6	15417	0.8%
7	9240	0.5%
8	11809	0.6%
9	7790	0.4%

Value	Count	Frequency (%)
1510592	1	< 0.1%
1427612	1	< 0.1%
1218328	2	< 0.1%
1126656	1	< 0.1%
1103084	1	< 0.1%
1092576	1	< 0.1%
1058396	1	< 0.1%
1046592	1	< 0.1%
1037228	1	< 0.1%
1021940	1	< 0.1%

forecast_6_month
Real number (ℝ)

SKEWED ZEROS

Distinct	11788
Distinct (%)	0.6%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	345.46607

Minimum	0
Maximum	2461360
Zeros	1240252
Zeros (%)	64.3%
Negative	0
Negative (%)	0.0%
Memory size	29.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	12
95-th percentile	600
Maximum	2461360
Range	2461360
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	9831.5646
Coefficient of variation (CV)	28.458843
Kurtosis	25080.966
Mean	345.46607
Median Absolute Deviation (MAD)	0
Skewness	138.81794
Sum	6.6672672 × 10⁸
Variance	96659663
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1240252	64.3%
1	31809	1.6%
2	30224	1.6%
3	22671	1.2%
4	21347	1.1%
5	19028	1.0%
6	18113	0.9%
10	17975	0.9%
8	14644	0.8%
20	13814	0.7%
Other values (11778)	500057	25.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1240252	64.3%
1	31809	1.6%
2	30224	1.6%
3	22671	1.2%
4	21347	1.1%
5	19028	1.0%
6	18113	0.9%
7	12868	0.7%
8	14644	0.8%
9	7656	0.4%

Value	Count	Frequency (%)
2461360	1	< 0.1%
2446072	1	< 0.1%
2157024	1	< 0.1%
2119148	1	< 0.1%
2109740	1	< 0.1%
2104128	1	< 0.1%
2094452	1	< 0.1%
2094336	1	< 0.1%
2087396	1	< 0.1%
2085044	1	< 0.1%

forecast_9_month
Real number (ℝ)

SKEWED ZEROS

Distinct	14523
Distinct (%)	0.8%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	506.60701

Minimum	0
Maximum	3777304
Zeros	1182117
Zeros (%)	61.3%
Negative	0
Negative (%)	0.0%
Memory size	29.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	20
95-th percentile	896
Maximum	3777304
Range	3777304
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	14345.435
Coefficient of variation (CV)	28.316692
Kurtosis	26835.195
Mean	506.60701
Median Absolute Deviation (MAD)	0
Skewness	142.68367
Sum	9.777181 × 10⁸
Variance	2.0579149 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1182117	61.3%
1	30475	1.6%
2	29263	1.5%
3	23594	1.2%
4	21986	1.1%
5	20113	1.0%
6	18689	1.0%
10	18365	1.0%
8	15698	0.8%
20	14264	0.7%
Other values (14513)	555370	28.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1182117	61.3%
1	30475	1.6%
2	29263	1.5%
3	23594	1.2%
4	21986	1.1%
5	20113	1.0%
6	18689	1.0%
7	11748	0.6%
8	15698	0.8%
9	8974	0.5%

Value	Count	Frequency (%)
3777304	1	< 0.1%
3760840	1	< 0.1%
3232820	1	< 0.1%
3229292	1	< 0.1%
3206948	1	< 0.1%
3196364	1	< 0.1%
3162260	1	< 0.1%
3158732	1	< 0.1%
3149324	1	< 0.1%
3124704	1	< 0.1%

sales_1_month
Real number (ℝ)

SKEWED ZEROS

Distinct	6088
Distinct (%)	0.3%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	55.368193

Minimum	0
Maximum	741774
Zeros	1100061
Zeros (%)	57.0%
Negative	0
Negative (%)	0.0%
Memory size	29.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4
95-th percentile	106
Maximum	741774
Range	741774
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1884.3775
Coefficient of variation (CV)	34.033574
Kurtosis	53099.568
Mean	55.368193
Median Absolute Deviation (MAD)	0
Skewness	193.71997
Sum	1.0685696 × 10⁸
Variance	3550878.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1100061	57.0%
1	165508	8.6%
2	90068	4.7%
3	56397	2.9%
4	43288	2.2%
5	33820	1.8%
6	27013	1.4%
7	21695	1.1%
8	19426	1.0%
10	16603	0.9%
Other values (6078)	356055	18.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1100061	57.0%
1	165508	8.6%
2	90068	4.7%
3	56397	2.9%
4	43288	2.2%
5	33820	1.8%
6	27013	1.4%
7	21695	1.1%
8	19426	1.0%
9	15957	0.8%

Value	Count	Frequency (%)
741774	1	< 0.1%
741762	1	< 0.1%
741750	1	< 0.1%
393665	1	< 0.1%
376025	1	< 0.1%
369425	1	< 0.1%
366191	1	< 0.1%
361803	1	< 0.1%
361239	1	< 0.1%
359505	1	< 0.1%

sales_3_month
Real number (ℝ)

SKEWED ZEROS

Distinct	11149
Distinct (%)	0.6%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	174.66395

Minimum	0
Maximum	1105478
Zeros	869086
Zeros (%)	45.0%
Negative	0
Negative (%)	0.0%
Memory size	29.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	15
95-th percentile	349
Maximum	1105478
Range	1105478
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	5188.8572
Coefficient of variation (CV)	29.70766
Kurtosis	24391.249
Mean	174.66395
Median Absolute Deviation (MAD)	1
Skewness	141.81394
Sum	3.3708989 × 10⁸
Variance	26924239
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	869086	45.0%
1	156660	8.1%
2	92910	4.8%
3	60714	3.1%
4	47486	2.5%
5	39014	2.0%
6	31848	1.7%
7	26572	1.4%
8	23870	1.2%
10	20385	1.1%
Other values (11139)	561389	29.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	869086	45.0%
1	156660	8.1%
2	92910	4.8%
3	60714	3.1%
4	47486	2.5%
5	39014	2.0%
6	31848	1.7%
7	26572	1.4%
8	23870	1.2%
9	20120	1.0%

Value	Count	Frequency (%)
1105478	1	< 0.1%
1104181	1	< 0.1%
1100523	1	< 0.1%
1099852	1	< 0.1%
1094112	1	< 0.1%
1091281	1	< 0.1%
1086554	1	< 0.1%
1084974	1	< 0.1%
1081560	1	< 0.1%
1076623	1	< 0.1%

sales_6_month
Real number (ℝ)

SKEWED ZEROS

Distinct	15813
Distinct (%)	0.8%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	341.56553

Minimum	0
Maximum	2146625
Zeros	739645
Zeros (%)	38.3%
Negative	0
Negative (%)	0.0%
Memory size	29.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	31
95-th percentile	696
Maximum	2146625
Range	2146625
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	9585.0329
Coefficient of variation (CV)	28.062062
Kurtosis	24221.359
Mean	341.56553
Median Absolute Deviation (MAD)	2
Skewness	138.92698
Sum	6.5919892 × 10⁸
Variance	91872855
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	739645	38.3%
1	145503	7.5%
2	90790	4.7%
3	60480	3.1%
4	47719	2.5%
5	39089	2.0%
6	32346	1.7%
7	26582	1.4%
8	24163	1.3%
9	21058	1.1%
Other values (15803)	702559	36.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	739645	38.3%
1	145503	7.5%
2	90790	4.7%
3	60480	3.1%
4	47719	2.5%
5	39089	2.0%
6	32346	1.7%
7	26582	1.4%
8	24163	1.3%
9	21058	1.1%

Value	Count	Frequency (%)
2146625	1	< 0.1%
2145715	1	< 0.1%
2133557	1	< 0.1%
2123946	1	< 0.1%
2117803	1	< 0.1%
2113901	1	< 0.1%
2112231	1	< 0.1%
2103389	1	< 0.1%
2098852	1	< 0.1%
2086531	1	< 0.1%

sales_9_month
Real number (ℝ)

SKEWED ZEROS

Distinct	19581
Distinct (%)	1.0%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	523.57736

Minimum	0
Maximum	3205172
Zeros	669802
Zeros (%)	34.7%
Negative	0
Negative (%)	0.0%
Memory size	29.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4
Q3	47
95-th percentile	1060
Maximum	3205172
Range	3205172
Interquartile range (IQR)	47

Descriptive statistics

Standard deviation	14733.269
Coefficient of variation (CV)	28.139623
Kurtosis	23014.498
Mean	523.57736
Median Absolute Deviation (MAD)	4
Skewness	135.43566
Sum	1.0104698 × 10⁹
Variance	2.1706923 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	669802	34.7%
1	137677	7.1%
2	87472	4.5%
3	59780	3.1%
4	47281	2.4%
5	39393	2.0%
6	32742	1.7%
7	26897	1.4%
8	24198	1.3%
9	21475	1.1%
Other values (19571)	783217	40.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	669802	34.7%
1	137677	7.1%
2	87472	4.5%
3	59780	3.1%
4	47281	2.4%
5	39393	2.0%
6	32742	1.7%
7	26897	1.4%
8	24198	1.3%
9	21475	1.1%

Value	Count	Frequency (%)
3205172	1	< 0.1%
3204929	1	< 0.1%
3201035	1	< 0.1%
3197338	1	< 0.1%
3195211	1	< 0.1%
3182148	1	< 0.1%
3167394	1	< 0.1%
3163794	1	< 0.1%
3120875	1	< 0.1%
3119450	1	< 0.1%

min_bank
Real number (ℝ)

SKEWED ZEROS

Distinct	5909
Distinct (%)	0.3%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	52.776393

Minimum	0
Maximum	313319
Zeros	997258
Zeros (%)	51.7%
Negative	0
Negative (%)	0.0%
Memory size	29.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	3
95-th percentile	125
Maximum	313319
Range	313319
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1257.9686
Coefficient of variation (CV)	23.835819
Kurtosis	23388.382
Mean	52.776393
Median Absolute Deviation (MAD)	0
Skewness	130.96258
Sum	1.0185496 × 10⁸
Variance	1582485
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	997258	51.7%
1	287930	14.9%
2	129167	6.7%
3	41408	2.1%
4	25511	1.3%
5	18360	1.0%
6	13865	0.7%
7	11042	0.6%
8	9010	0.5%
15	8422	0.4%
Other values (5899)	387961	20.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	997258	51.7%
1	287930	14.9%
2	129167	6.7%
3	41408	2.1%
4	25511	1.3%
5	18360	1.0%
6	13865	0.7%
7	11042	0.6%
8	9010	0.5%
9	7035	0.4%

Value	Count	Frequency (%)
313319	1	< 0.1%
311423	1	< 0.1%
310427	1	< 0.1%
309667	1	< 0.1%
308055	1	< 0.1%
307627	1	< 0.1%
303713	1	< 0.1%
291059	1	< 0.1%
205786	1	< 0.1%
204803	1	< 0.1%

potential_issue
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	18.4 MiB

False	1928945
True	989
(Missing)	1

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1928945	99.9%
True	989	0.1%
(Missing)	1	< 0.1%

pieces_past_due
Real number (ℝ)

SKEWED ZEROS

Distinct	874
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2.0161943

Minimum	0
Maximum	146496
Zeros	1901631
Zeros (%)	98.5%
Negative	0
Negative (%)	0.0%
Memory size	29.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	146496
Range	146496
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	229.6113
Coefficient of variation (CV)	113.88352
Kurtosis	210414.07
Mean	2.0161943
Median Absolute Deviation (MAD)	0
Skewness	414.26988
Sum	3891122
Variance	52721.35
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1901631	98.5%
1	4350	0.2%
2	2406	0.1%
4	1395	0.1%
3	1357	0.1%
5	1184	0.1%
6	923	< 0.1%
12	855	< 0.1%
10	841	< 0.1%
8	691	< 0.1%
Other values (864)	14301	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1901631	98.5%
1	4350	0.2%
2	2406	0.1%
3	1357	0.1%
4	1395	0.1%
5	1184	0.1%
6	923	< 0.1%
7	550	< 0.1%
8	691	< 0.1%
9	431	< 0.1%

Value	Count	Frequency (%)
146496	1	< 0.1%
137625	1	< 0.1%
98776	1	< 0.1%
87689	1	< 0.1%
83600	1	< 0.1%
79964	1	< 0.1%
74084	1	< 0.1%
61144	1	< 0.1%
59136	1	< 0.1%
36452	1	< 0.1%

perf_6_month_avg
Real number (ℝ)

Distinct	102
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	-6.8998218

Minimum	-99
Maximum	1
Zeros	44675
Zeros (%)	2.3%
Negative	148578
Negative (%)	7.7%
Memory size	29.4 MiB

Quantile statistics

Minimum	-99
5-th percentile	-99
Q1	0.63
median	0.82
Q3	0.96
95-th percentile	1
Maximum	1
Range	100
Interquartile range (IQR)	0.33

Descriptive statistics

Standard deviation	26.599803
Coefficient of variation (CV)	-3.8551435
Kurtosis	8.0712063
Mean	-6.8998218
Median Absolute Deviation (MAD)	0.15
Skewness	-3.1733535
Sum	-13316201
Variance	707.54953
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.99	163323	8.5%
1	150339	7.8%
-99	148578	7.7%
0.73	128818	6.7%
0.98	97390	5.0%
0.97	71120	3.7%
0.95	50482	2.6%
0.78	49056	2.5%
0.82	46602	2.4%
0	44675	2.3%
Other values (92)	979551	50.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-99	148578	7.7%
0	44675	2.3%
0.01	648	< 0.1%
0.02	1156	0.1%
0.03	829	< 0.1%
0.04	724	< 0.1%
0.05	1352	0.1%
0.06	1393	0.1%
0.07	2569	0.1%
0.08	1947	0.1%

Value	Count	Frequency (%)
1	150339	7.8%
0.99	163323	8.5%
0.98	97390	5.0%
0.97	71120	3.7%
0.96	44116	2.3%
0.95	50482	2.6%
0.94	43978	2.3%
0.93	39878	2.1%
0.92	25924	1.3%
0.91	33770	1.7%

perf_12_month_avg
Real number (ℝ)

Distinct	102
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	-6.462295

Minimum	-99
Maximum	1
Zeros	37885
Zeros (%)	2.0%
Negative	140024
Negative (%)	7.3%
Memory size	29.4 MiB

Quantile statistics

Minimum	-99
5-th percentile	-99
Q1	0.66
median	0.81
Q3	0.95
95-th percentile	0.99
Maximum	1
Range	100
Interquartile range (IQR)	0.29

Descriptive statistics

Standard deviation	25.88335
Coefficient of variation (CV)	-4.0052875
Kurtosis	8.8594215
Mean	-6.462295
Median Absolute Deviation (MAD)	0.15
Skewness	-3.2951974
Sum	-12471803
Variance	669.94779
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.99	152682	7.9%
-99	140024	7.3%
0.78	131353	6.8%
0.98	106119	5.5%
0.97	74113	3.8%
0.96	72752	3.8%
0.66	61831	3.2%
0.9	53203	2.8%
0.95	53112	2.8%
1	50443	2.6%
Other values (92)	1034302	53.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-99	140024	7.3%
0	37885	2.0%
0.01	2814	0.1%
0.02	437	< 0.1%
0.03	639	< 0.1%
0.04	1179	0.1%
0.05	743	< 0.1%
0.06	873	< 0.1%
0.07	1193	0.1%
0.08	1720	0.1%

Value	Count	Frequency (%)
1	50443	2.6%
0.99	152682	7.9%
0.98	106119	5.5%
0.97	74113	3.8%
0.96	72752	3.8%
0.95	53112	2.8%
0.94	43409	2.2%
0.93	35577	1.8%
0.92	35805	1.9%
0.91	34296	1.8%

local_bo_qty
Real number (ℝ)

SKEWED ZEROS

Distinct	686
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.65370422

Minimum	0
Maximum	12530
Zeros	1903730
Zeros (%)	98.6%
Negative	0
Negative (%)	0.0%
Memory size	29.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	12530
Range	12530
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	35.432305
Coefficient of variation (CV)	54.20235
Kurtosis	30837.955
Mean	0.65370422
Median Absolute Deviation (MAD)	0
Skewness	149.62088
Sum	1261606
Variance	1255.4482
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1903730	98.6%
1	8055	0.4%
2	3332	0.2%
3	1930	0.1%
4	1381	0.1%
5	1098	0.1%
6	756	< 0.1%
7	621	< 0.1%
10	566	< 0.1%
8	501	< 0.1%
Other values (676)	7964	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1903730	98.6%
1	8055	0.4%
2	3332	0.2%
3	1930	0.1%
4	1381	0.1%
5	1098	0.1%
6	756	< 0.1%
7	621	< 0.1%
8	501	< 0.1%
9	382	< 0.1%

Value	Count	Frequency (%)
12530	1	< 0.1%
10045	1	< 0.1%
10024	1	< 0.1%
8600	1	< 0.1%
7812	1	< 0.1%
7048	1	< 0.1%
7000	1	< 0.1%
6965	1	< 0.1%
6955	1	< 0.1%
6732	1	< 0.1%

deck_risk
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	18.4 MiB

False	1494481
True	435453
(Missing)	1

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1494481	77.4%
True	435453	22.6%
(Missing)	1	< 0.1%

oe_constraint
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	18.4 MiB

False	1929642
True	292
(Missing)	1

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1929642	> 99.9%
True	292	< 0.1%
(Missing)	1	< 0.1%

ppap_risk
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	18.4 MiB

False	1697382
True	232552
(Missing)	1

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1697382	88.0%
True	232552	12.0%
(Missing)	1	< 0.1%

stop_auto_buy
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	18.4 MiB

True	1859390
False	70544
(Missing)	1

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	1859390	96.3%
False	70544	3.7%
(Missing)	1	< 0.1%

rev_stop
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	18.4 MiB

False	1929095
True	839
(Missing)	1

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1929095	> 99.9%
True	839	< 0.1%
(Missing)	1	< 0.1%

went_on_backorder
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	18.4 MiB

False	1915953
True	13981
(Missing)	1

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1915953	99.3%
True	13981	0.7%
(Missing)	1	< 0.1%

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	sku	national_inv	lead_time	forecast_3_month	forecast_6_month	forecast_9_month	sales_9_month	min_bank	potential_issue	perf_6_month_avg	perf_12_month_avg	deck_risk	oe_constraint	ppap_risk	stop_auto_buy	rev_stop	went_on_backorder
0	1026827	0.0	NaN	0.0	0.0	0.0	0.0	0.0	No	-99.00	-99.00	No	No	No	Yes	No	No
1	1043384	2.0	9.0	0.0	0.0	0.0	0.0	0.0	No	0.99	0.99	No	No	No	Yes	No	No
2	1043696	2.0	NaN	0.0	0.0	0.0	0.0	0.0	No	-99.00	-99.00	Yes	No	No	Yes	No	No
3	1043852	7.0	8.0	0.0	0.0	0.0	0.0	1.0	No	0.10	0.13	No	No	No	Yes	No	No
4	1044048	8.0	NaN	0.0	0.0	0.0	4.0	2.0	No	-99.00	-99.00	Yes	No	No	Yes	No	No
5	1044198	13.0	8.0	0.0	0.0	0.0	0.0	0.0	No	0.82	0.87	No	No	No	Yes	No	No
6	1044643	1095.0	NaN	0.0	0.0	0.0	0.0	4.0	No	-99.00	-99.00	Yes	No	No	Yes	No	No
7	1045098	6.0	2.0	0.0	0.0	0.0	0.0	0.0	No	0.00	0.00	Yes	No	Yes	Yes	No	No
8	1045815	140.0	NaN	15.0	114.0	152.0	0.0	0.0	No	-99.00	-99.00	No	No	No	Yes	No	No
9	1045867	4.0	8.0	0.0	0.0	0.0	0.0	0.0	No	0.82	0.87	No	No	No	Yes	No	No

	sku	national_inv	lead_time	forecast_3_month	forecast_6_month	forecast_9_month	sales_1_month	sales_3_month	sales_6_month	sales_9_month	min_bank	potential_issue	perf_6_month_avg	perf_12_month_avg	deck_risk	oe_constraint	ppap_risk	stop_auto_buy	rev_stop	went_on_backorder
242065	3526982	20.0	12.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	No	0.48	0.48	Yes	No	No	Yes	No	No
242066	3526983	50.0	12.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	No	0.48	0.48	Yes	No	Yes	Yes	No	No
242067	3526984	20.0	12.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	No	0.48	0.48	Yes	No	No	Yes	No	No
242068	3526985	165.0	NaN	56.0	180.0	273.0	21.0	86.0	215.0	314.0	40.0	No	-99.00	-99.00	No	No	No	Yes	No	No
242069	3526986	11.0	12.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	No	0.48	0.48	Yes	No	No	Yes	No	No
242070	3526987	12.0	12.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	No	0.48	0.48	Yes	No	No	Yes	No	No
242071	3526988	13.0	12.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	No	0.48	0.48	Yes	No	No	Yes	No	No
242072	3526989	13.0	12.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	No	0.48	0.48	Yes	No	No	Yes	No	No
242073	3526990	10.0	12.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	No	0.48	0.48	Yes	No	No	Yes	No	No
242074	3526991	2913.0	12.0	0.0	0.0	0.0	0.0	30.0	88.0	88.0	4.0	No	0.48	0.48	Yes	No	No	Yes	No	No

Most frequently occurring

	national_inv	lead_time	min_bank	potential_issue	perf_6_month_avg	perf_12_month_avg	deck_risk	oe_constraint	ppap_risk	stop_auto_buy	rev_stop	went_on_backorder	# duplicates
13440	0.0	NaN	0.0	No	-99.00	-99.00	No	No	No	Yes	No	No	7893
99496	13.0	12.0	1.0	No	0.48	0.48	Yes	No	No	Yes	No	No	3792
30231	2.0	12.0	0.0	No	0.73	0.79	No	No	No	Yes	No	No	3254
23603	2.0	4.0	0.0	No	0.73	0.78	No	No	No	Yes	No	No	3178
30251	2.0	12.0	0.0	No	0.78	0.78	No	No	No	Yes	No	No	3140
87337	10.0	12.0	1.0	No	0.48	0.48	Yes	No	No	Yes	No	No	3036
29060	2.0	9.0	0.0	No	0.70	0.66	No	No	No	Yes	No	No	2800
30199	2.0	12.0	0.0	No	0.57	0.68	No	No	No	Yes	No	No	2569
30210	2.0	12.0	0.0	No	0.63	0.72	No	No	No	Yes	No	No	2534
40810	3.0	12.0	0.0	No	0.57	0.68	No	No	No	Yes	No	No	2199

Overview

Variables

Interactions

Missing values

Sample

Duplicate rows

Most frequently occurring